# IMPORTING NECESSARY LIBRARIES

#For document
import docx
from docx import Document
from docx.shared import Inches

#For function
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd #To read Excel File
import csv #To write as csv file
from sklearn import ensemble
from sklearn import datasets
from sklearn.utils import shuffle
from sklearn.metrics import mean_squared_error

# DEFINING OUR FUNCTION

#Names
#excel_name = 'Data/Glucose W4 no Omics.xlsx'
#output_name = 'Glucose W4 UwnO.csv'
#target_name = 'Glucose'

def mse_images(excel_name,target_name,output_name,extension):
    #Loading the data
    dataset = pd.read_excel(excel_name)
    dataset = np.asarray(dataset)
    
    #Separating data by data, target, feature_names
    feature_names = dataset[0,2:(dataset.shape[1] - 1)] # all variables except for target variable and ID
    target = dataset[1:74,(dataset.shape[1] - 1)] # target variable...what we're trying to predict
    data = dataset[1:74,2:(dataset.shape[1] - 1)] # missing target, ID,  feature_names
    
    #Randomizing target & data and placing them in y & x respectively
    X, y = shuffle(data, target, random_state=13)
    X = X.astype(np.float32)
    y = y.astype(np.float32)
    
    #Splitting data into the trainning vs. testing set
    cutoff = int(X.shape[0] * 0.9)
    X_train, y_train = X[:cutoff], y[:cutoff]
    X_test, y_test = X[cutoff:], y[cutoff:]
    
    # Fit regression model
    params = {'n_estimators': 500, 'max_depth': 1, 'min_samples_split': 2,'learning_rate': 0.1, 'loss': 'ls'}
    clf = ensemble.GradientBoostingRegressor(**params)
    clf.fit(X_train, y_train)
    mse = mean_squared_error(y_test, clf.predict(X_test))
    print("MSE: %.4f" % mse) #*********************************************************************************!!!!!!!!!!!!!
    predicted = clf.predict(X_test)
    actual = y_test
    predicted_index = np.argsort(predicted)
    actual_index = np.argsort(actual)
    
    #Display Predicted vs Actual
    plt.figure(figsize=(12, 6))
    plt.subplot(1, 2, 1)
    plt.title('Predictions')
    plt.plot(predicted[predicted_index],  'b-',label='PREDICTED')
    plt.plot(actual[actual_index],'r-',label='ACTUAL')
    plt.legend(loc='upper right')
    plt.xlabel('Index')
    plt.ylabel(target_name)
    
    # compute test set deviance
    test_score = np.zeros((params['n_estimators'],), dtype=np.float64)
    for i, y_pred in enumerate(clf.staged_predict(X_test)):
        test_score[i] = clf.loss_(y_test, y_pred)
    
    #Display Deviance Plot
    #plt.figure(figsize=(12, 6))
    plt.subplot(1, 2, 2)
    plt.title('Deviance')
    plt.plot(np.arange(params['n_estimators']) + 1, clf.train_score_, 'b-',label='Training Set Deviance')
    plt.plot(np.arange(params['n_estimators']) + 1, test_score, 'r-',
    label='Test Set Deviance')
    plt.legend(loc='upper right')
    plt.xlabel('Boosting Iterations')
    plt.ylabel('Deviance')
    image2 = extension + output_name + '.png'
    plt.savefig(image2, bbox_inches='tight')
    # Plot feature importance
    feature_importance = clf.feature_importances_
    
    # make importances relative to max importance
    feature_importance = 100.0 * (feature_importance / feature_importance.max())
    sorted_idx = np.argsort(-feature_importance)
    #For table
    results = np.array(range(len(feature_names[sorted_idx]))).tolist()
    indexval = 0
    count = []
    for i in range(len(feature_names[sorted_idx])): 
        if (feature_importance[sorted_idx][indexval] == 0):
            count.append(indexval)
        results[indexval] = [feature_names[sorted_idx][indexval], feature_importance[sorted_idx][indexval]]
        indexval += 1
    del(results[count[0]:len(results)])
    return mse,results;

# STARTING OUR DOCUMENT
document = Document()

#Title
document.add_heading('Datasets Results', 0)

#SwnO
document.add_heading('SwnO', level=1)
dataset = 'SwnO'
extension = 'Images/' + dataset + '/'
folder = 'Standardized Data no Omics'
document.add_heading('BL',level=2)
week = 'BL'
####################################################################################################################!
####################################################################################################################! BL Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1111 = mse
results1111 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2111 = mse
results2111 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1211 = mse
results1211 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2211 = mse
results2211 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1311 = mse
results1311 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2311 = mse
results2311 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1411 = mse
results1411 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2411 = mse
results2411 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('W4',level=2)
week = 'W4'
####################################################################################################################!
####################################################################################################################! W4 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1121 = mse
results1121 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL' 
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2121 = mse
results2121 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W4 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1221 = mse
results1221 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2221 = mse
results2221 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W4 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1321 = mse
results1321 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2321 = mse
results2321 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('W8',level=2)
week = 'W8'
####################################################################################################################!
####################################################################################################################! W8 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1131 = mse
results1131 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2131 = mse
results2131 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1231 = mse
results1231 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2231 = mse
results2231 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1331 = mse
results1331 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2331 = mse
results2331 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1431 = mse
results1431 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2431 = mse
results2431 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('Delta4',level = 2)
week = 'Delta 4'
####################################################################################################################!
####################################################################################################################! D4 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1141 = mse
results1141 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2141 = mse
results2141 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(3))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D4 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1241 = mse
results1241 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2241 = mse
results2241 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D4 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1341 = mse
results1341 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2341 = mse
results2341 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))


document.add_heading('Delta8',level=2)
week = 'Delta 8'
####################################################################################################################!
####################################################################################################################! D8 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1151 = mse
results1151 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2151 = mse
results2151 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1251 = mse
results1251 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2251 = mse
results2251 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1351 = mse
results1351 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2351 = mse
results2351 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1451 = mse
results1451 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2451 = mse
results2451 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

#Swo
document.add_heading('SwO', level=1)
dataset = 'SwO'
extension = 'Images/' + dataset + '/'
folder = 'Standardized Data w Omics'
document.add_heading('BL',level=2)
week = 'BL'
####################################################################################################################!
####################################################################################################################! BL Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1112 = mse
results1112 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2112 = mse
results2112 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1212 = mse
results1212 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2212 = mse
results2212 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1312 = mse
results1312 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2312 = mse
results2312 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! BL RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1412 = mse
results1412 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2412 = mse
results2412 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('W4',level=2)
week = 'W4'
####################################################################################################################!
####################################################################################################################! W4 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1122 = mse
results1122 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL' 
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2122 = mse
results2122 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W4 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1222 = mse
results1222 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2222 = mse
results2222 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W4 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1322 = mse
results1322 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2322 = mse
results2322 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('W8',level=2)
week = 'W8'
####################################################################################################################!
####################################################################################################################! W8 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1132 = mse
results1132 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2132 = mse
results2132 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1232 = mse
results1232 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2232 = mse
results2232 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1332 = mse
results1332 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2332 = mse
results2332 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! W8 RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1432 = mse
results1432 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2432 = mse
results2432 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))

document.add_heading('Delta4',level = 2)
week = 'Delta 4'
####################################################################################################################!
####################################################################################################################! D4 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1142 = mse
results1142 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2142 = mse
results2142 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(3))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D4 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1242 = mse
results1242 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2242 = mse
results2242 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D4 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1342 = mse
results1342 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2342 = mse
results2342 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))


document.add_heading('Delta8',level=2)
week = 'Delta 8'
####################################################################################################################!
####################################################################################################################! D8 Raw
document.add_heading('Raw',level=3)
part = 'Raw'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1152 = mse
results1152 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2152 = mse
results2152 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RZ
document.add_heading('Removed Zero Columns',level=3)
part = 'RZ'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1252 = mse
results1252 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2252 = mse
results2252 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RB
document.add_heading('Removed Blood Measurements',level=3)
part = 'RB'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1352 = mse
results1352 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2352 = mse
results2352 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
####################################################################################################################!
####################################################################################################################! D8 RBM
document.add_heading('Removed Blood and Microbiome',level=3)
part = 'RBM'
document.add_heading('Glucose',level=4)
target_name = 'Glucose'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse1452 = mse
results1452 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))
document.add_heading('HDL',level=4)
target_name = 'HDL'
#_______________________________________________________________________
excel_name = folder+'/Data/'+part+ '/'+ target_name+' '+ week+' '+dataset+'.xlsx'
output_name = part + target_name + week + dataset
mse,results = mse_images(excel_name,target_name,output_name, extension)
mse2452 = mse
results2452 = results
document.add_paragraph('The mse value '+ target_name + ' '+ week +' is '+str(mse))
pic1 = 'Images\\'+ dataset + '\\' + output_name + '.png'
document.add_picture(pic1,width=Inches(5))
table = document.add_table(rows=1, cols=2)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Variable Name'
hdr_cells[1].text = 'Importance'
for name, imp in results:
    row_cells = table.add_row().cells  
    row_cells[0].text = name
    row_cells[1].text = str(round(imp,2))